Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Constraints
1) A check constraint uses an expression to qualify records that are acceptable for any Inserts or Updates
2) A NOT NULL phrase adds a constraint to restrict the input of rows with a null value
3) A statement that adds a foreign key constraint
4) A table-level check constraint that limits Banker IDs to a specific format
5) Adding a CHECK Constraint to an Existing Table
6) Adding a FOREIGN KEY to the Employees Table
7) Adding a UNIQUE Constraint to an Existing Table
8) Cascading Updates and Deletes
9) CHECK (DATEPART(DAY, GETDATE()) 28)
10) CHECK Clause
11) Check Constraint
12) Check for data length
13) Column with default random value
14) Constraints
15) Constraints with name
16) Creating a UNIQUE Constraints when creating a table
17) Creating UNIQUE Constraints on Existing Tables
18) Creation of Default Values
19) DEFAULT Constraints
20) Default int type value and default char type value
21) Defaults
22) Define constraint name for primary key
23) Define Rules
24) Designating Default Column Values
25) Disable checking on all constraints
26) Disabling and Enabling a Constraint
27) Dropping a Constraint from a Table
28) Dropping Defaults
29) Enable checking on all constraints
30) Exception in a transaction
31) EXEC sp_helptext on Rules
32) FOREIGN KEY Constraints
33) Insert to a table with default value
34) Making a Table be Self-Referencing
35) Mark nocheck for a constraint
36) NONCLUSTERED PRIMARY KEY
37) ON DELETE and ON UPDATE Options
38) ON UPDATE CASCADE ON DELETE NO ACTION
39) Pattern based constraint
40) PRIMARY KEY (cust_id)
41) Primary key and foreign key
42) Primary Key Constraint
43) Re-creating the FOREIGN KEY with NO ACTION (Implicitly)
44) REFERENCES customer(cust_id) (from another table)
45) Referential Constraints
46) Sample Table Using the uniqueidentifier and NEWID() Function
47) Self-Referencing Tables
48) Supporting Basic Referential Integrity with Foreign Keys
49) The FOREIGN KEY Clause
50) The PRIMARY KEY Clause
51) The syntax for defining a default
52) Trap Both Primary Key and CHECK Constraint Violations
53) Unique Constraint
54) Unique constraints can be created when initially creating the table or added after
55) Unique constraints will also allow one NULL, whereas primary keys will not
56) UniqueIdentifier are either explicitly provided or they are generated by the NEWID() system function
57) Update statement and check-constraints
58) Use or to link two conditions for check constraint
59) Using a Multicolumn CHECK Constraint
60) Using a Multicolumn Primary Key
61) Using CHECK Constraints
62) Using the system date as a default parameter
63) You cannot add another primary key to table